CREATE TABLE [dbo].[tb_AsignacionServiciosExtraordinarios]
(
[idAsignacionSE] [int] NOT NULL IDENTITY(1, 1),
[Alumno] [int] NOT NULL,
[TipoDeServicio] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Organizacion] [int] NOT NULL,
[Plaza] [int] NULL,
[Desde] [datetime] NOT NULL,
[Baja] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Hasta] [datetime] NULL,
[Observaciones] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_AsignacionServiciosExtraordinarios] ADD CONSTRAINT [PK_tb_AsignacionServiciosExtraordinarios] PRIMARY KEY NONCLUSTERED  ([idAsignacionSE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [idx_Alumno] ON [dbo].[tb_AsignacionServiciosExtraordinarios] ([Alumno]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_AsignacionServiciosExtraordinarios] WITH NOCHECK ADD CONSTRAINT [FK_tb_AsignacionServiciosExtraordinarios_tb_Organizaciones] FOREIGN KEY ([Organizacion]) REFERENCES [dbo].[tb_Organizaciones] ([idOrganizaciones])
GO
ALTER TABLE [dbo].[tb_AsignacionServiciosExtraordinarios] WITH NOCHECK ADD CONSTRAINT [FK_tb_AsignacionServiciosExtraordinarios_tb_Plazas] FOREIGN KEY ([Plaza]) REFERENCES [dbo].[tb_Plazas] ([idPlaza])
GO
ALTER TABLE [dbo].[tb_AsignacionServiciosExtraordinarios] WITH NOCHECK ADD CONSTRAINT [FK_tb_AsignacionServiciosExtraordinarios_tb_TipoServicioExtraordinario] FOREIGN KEY ([TipoDeServicio]) REFERENCES [dbo].[tb_TipoServicioExtraordinario] ([idTipoServicio])
GO
